package com.itheima.mapper;

import com.itheima.entity.Student;
import com.itheima.entity.StudentQueryParam;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * @Description StudentMapper
 * @Author 你的名字拼接或昵称
 * @Date 2025-09-06
 */
@Mapper
public interface StudentMapper {

    List<Student> list(StudentQueryParam studentQueryParam);

    void save(Student student);

    Student getid(Integer id);

    void update(Student student);

    void delete(List<Integer> ids);

    @Select("select *from student where id=#{id}")
    Student getInfo(Integer id);

    void updateviolation(Integer id, int violationCount, int violationScore);

    List<Map<String, Object>> studentCount();
}
